INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_pricing.price FROM xcart_products, xcart_pricing , xcart_products_categories LEFT JOIN xcart_extra_field_values ON xcart_products.productid = xcart_extra_field_values.productid LEFT JOIN xcart_extra_fields ON xcart_extra_field_values.fieldid = xcart_extra_fields.fieldid AND xcart_extra_fields.active = 'Y' WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_pricing.variantid = 0 AND ((xcart_extra_field_values.value LIKE '%CD Single%' AND xcart_extra_fields.fieldid = '1')) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid='119' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_pricing.price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories LEFT JOIN xcart_extra_field_values ON xcart_products.productid = xcart_extra_field_values.productid LEFT JOIN xcart_extra_fields ON xcart_extra_field_values.fieldid = xcart_extra_fields.fieldid AND xcart_extra_fields.active = 'Y' WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='119' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_pricing.variantid = 0 AND ((xcart_extra_field_values.value LIKE '%CD Single%' AND xcart_extra_fields.fieldid = '1')) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid
It's The King!! First 2 Elvis LPs in stock at the moment plus we usually have a smattering of interesting memorabilia/fan club stuff plus orginal 7" singles by the likes of Jerry Lee Lewis and Eddie Cochran. Quite a few nice compilations and box sets plus ::
Rock 'N' Roll/Rockabilly/DooWop
:: Music
:: Elvis Shakespeare
Opening Hours
Mon-Sat: 10.00-18.00
Sun: Closed for the winter (open again in May)
Nice collection of Rock N Roll/DooWop CDs just in. orginal 7" singles by the likes of Jerry Lee Lewis and Eddie Cochran. Quite a few nice compilations and box sets plus a smattering of modern Rockabilly & Psychobilly by the likes of The Guana Batz, Stingrays, Cannibals, King Kurt: basically anyone with a twangy guitar (hello Mr Eddy) can be found here.
Rock 'N' Roll/Rockabilly/DooWop
There are no available products under this category.
It's The King!! First 2 Elvis LPs in stock at the moment plus we usually have a smattering of interesting memorabilia/fan club stuff plus orginal 7" singles by the likes of Jerry Lee Lewis and Eddie Cochran. Quite a few nice compilations and box sets plus ::
Rock 'N' Roll/Rockabilly/DooWop
:: Music
:: Elvis Shakespeare